<?php

session_start();
if(!array_key_exists("user", $_SESSION) || $_SESSION['account'] != 1){
	header("Location: ../common/redirect.php");
	exit;
}

include_once("../class/db.php");
$db = new db();

$sql = "SELECT course_modules.id FROM course, course_modules WHERE course.school_id = '{$_SESSION['school_id']}' AND course.grade = '{$_SESSION['grade']}' AND course.link = course_modules.link";
$user_temp_course_data = $db->execute($sql, "all");

$temp_data = array();
foreach($user_temp_course_data as $user_temp_courses){
	$temp_data[] = $user_temp_courses['id'];
}

$sql = "SELECT uid, id, title, start_date, end_date FROM course_content WHERE contenttype = 'exam' AND uid IN (".implode(",", $temp_data).")";
$user_exam_data = $db->execute($sql, "all");

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PIE EDUCATION | My Exams</title>
<link rel="stylesheet" type="text/css" href="/css/style-student.css" />
<link href="/css/jquery-ui.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="/js/index.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script>
<script language="Javascript1.2">
<!--
setTimeout('location.href="/logout.php?expire=1"',600000);
// -->
</script>
<script>
	$(document).ready(function() {
		$("#accordion").accordion({ autoHeight: false });
	});
</script>
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-35230372-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>
</head>

<body>
<form action="take_advice.php" method="post" name="take_test" id="take_test">
<input name="exam_id" id="exam_id" type="hidden" value="#" />
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td bgcolor="#000000"><table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="350" height="30">&nbsp;</td>
        <td align="right" valign="bottom"><a href="class.php" class="top-menu" style="color:#999">MY COURSES</a> <a href="schedule.php" class="top-menu" style="color:#999">CALENDAR</a> <a href="homework.php" class="top-menu" style="color:#999">HOMEWORK</a> <a href="test.php" class="top-menu" style="color:#999">EXAMS</a>  <a href="history.php" class="top-menu" style="color:#999">RECORDS</a> <a href="tools.php" class="top-menu" style="color:#999">TOOLS</a> <a href="/logout.php" class="top-menu" style="color:#999">SIGN OUT</a></td>
      </tr>
	  <tr>
        <td>&nbsp;</td>
        <td align="right" valign="bottom"><a href="/profile/" class="login-menu" style="color:#FFF"><?php echo $_SESSION['name'].' '.$_SESSION['lname']; ?></a> <a href="/common/settings.php" class="login-menu" style="color:#FFF">Change Settings</a> <a href="/common/redirect.php" class="login-menu" style="color:#FFF">My Documents</a> <a href="/network/" class="login-menu" style="color:#FFF">My Network</a></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="30" style="background-image:url(/images/top-bg-student.png); background-repeat:repeat-x">&nbsp;</td>
  </tr>
  <tr>
    <td height="700" valign="top">
    <?php
    if($user_exam_data == false){
    echo '<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td height="100" align="center" style="font-family:Arial, Helvetica, sans-serif; font-size:14px; color: #666"><strong>You still not have any exam pending, please come back later and try again</strong></td>
      </tr>
    </table>';
    } else {
      echo '<table width="980" border="0" align="center" cellpadding="4" cellspacing="4">
      <tr>
        <td width="40%" style="font-size:14px; font-family:Arial, Helvetica, sans-serif;border-bottom-color:#CCC; border-bottom:thin; border-bottom-style:dashed; padding-bottom:10px"><strong>Title</strong></td>
        <td width="20%" align="center" style="font-size:14px; font-family:Arial, Helvetica, sans-serif;border-bottom-color:#CCC; border-bottom:thin; border-bottom-style:dashed; padding-bottom:10px"><strong>Start Date</strong></td>
        <td width="20%" align="center" style="font-size:14px; font-family:Arial, Helvetica, sans-serif;border-bottom-color:#CCC; border-bottom:thin; border-bottom-style:dashed; padding-bottom:10px"><strong>End Date</strong></td>
        <td width="20%" align="center" style="font-size:14px; font-family:Arial, Helvetica, sans-serif;border-bottom-color:#CCC; border-bottom:thin; border-bottom-style:dashed; padding-bottom:10px"><strong>Take Exam</strong></td>
      </tr>';
      foreach($user_exam_data as $user_exams){
		  
		  $dates = explode(" ", $user_exams['start_date']);
		  list($year, $month, $day) = explode("-", $dates[0]);
		  list($hour, $minute, $second) = explode(":", $dates[1]);
		  
		  $dates = explode(" ", $user_exams['end_date']);
		  list($year2, $month2, $day2) = explode("-", $dates[0]);
		  list($hour2, $minute2, $second2) = explode(":", $dates[1]);
		  echo '<tr>
			<td style="font-family:Arial, Helvetica, sans-serif; font-size:12px">'.$user_exams['title'].'</td>
			<td align="center" style="font-family:Arial, Helvetica, sans-serif; font-size:12px">';
			if($user_exams['start_date'] == "0000-00-00 00:00:00"){
				echo '<span style="color:#6C0">No Start Date</span>';
			} else {
				echo date("d F  H:i", mktime($hour, $minute, $second, $month, $day, $year));
			}
			echo '</td>
			<td align="center" style="font-family:Arial, Helvetica, sans-serif; font-size:12px">';
			if($user_exams['end_date'] == "0000-00-00 00:00:00"){
				echo '<span style="color:#6C0">No End Date</span>';
			} else {
				echo date("d F  H:i", mktime($hour2, $minute2, $second2, $month2, $day2, $year2));
			}
			echo '</td>
			<td align="center" style="font-family:Arial, Helvetica, sans-serif; font-size:12px;color:#F00">';
			$exam_start_date = mktime($hour, $minute, $second, $month, $day, $year);
			$exam_end_date = mktime($hour2, $minute2, $second2, $month2, $day2, $year2);
			$exam_now_time = mktime(date("H"), date("i"), date("s"), date("m"), date("d"), date("Y"));
			
			if(($exam_start_date <= $exam_now_time && $user_exams['end_date'] == "0000-00-00 00:00:00") || ($user_exams['start_date'] == "0000-00-00 00:00:00" && $exam_end_date >= $exam_now_time) || ($user_exams['start_date'] == "0000-00-00 00:00:00" && $user_exams['end_date'] == "0000-00-00 00:00:00") || ($exam_start_date <= $exam_now_time && $exam_end_date >= $exam_now_time)){
				echo '<a href="#" onclick="javascript:take_exam('.$user_exams['id'].')"><strong>Go to exam</strong></a>';
			} else {
				echo "<strong>Pending</strong>";
			}
			
			echo '</td>
		  </tr>';
      }
    echo '</table>';
    }
    ?>
    </td>
  </tr>
  <tr>
    <td height="30" style=" background-image:url(../images/bottom-bg-student.png); background-repeat:repeat-x;">&nbsp;</td>
  </tr>
  <tr>
    <td height="50" align="center" bgcolor="#000000" style="color:#fff; font-family:Arial, Helvetica, sans-serif">PIE.EDU All Rights Reserved 2012<br />
      <a href="/common/privacy.php" class="bottom-menu" style="color:#999">Privacy Policy</a> | <a href="/common/terms.php" class="bottom-menu"  style="color:#999">Terms of Use</a> | <a href="/help/main.php" class="bottom-menu" style="color:#999">Help Center</a> | <a href="/common/jobs.php" class="bottom-menu" style="color:#999">Jobs</a></td>
  </tr>
</table>
</form>
</body>
</html>